Tabela LAccountTemplatePosition

Definicja tabeli LAccountTemplatePosition

Name

LAccountTemplatePosition

Code

LAccountTemplatePosition

Comment

Tabela przechowuje informacje o produktach kontraktowych i wartosciach dla nich w ramach szablonów NFZ


Lista kolumn tabeli LAccountTemplatePosition

Name

Code

LAccountTemplatePositionID

LAccountTemplatePositionID

AccountTemplateID

AccountTemplateID

Con_ContractServiceID

Con_ContractServiceID

ContractServiceID

ContractServiceID

FullName

FullName

UnitsCount

UnitsCount

VatRate

VatRate

UnitPrice

UnitPrice

PositionNumber

PositionNumber

Charge

Charge

CorrectionFactor

CorrectionFactor

CapitationRate

CapitationRate

CorrectionReason

CorrectionReason


Kolumna LAccountTemplatePositionID tabeli LAccountTemplatePosition

Definicja kolumny LAccountTemplatePositionID tabeli LAccountTemplatePosition

Name

LAccountTemplatePositionID

Code

LAccountTemplatePositionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AccountTemplateID tabeli LAccountTemplatePosition

Definicja kolumny AccountTemplateID tabeli LAccountTemplatePosition

Name

AccountTemplateID

Code

AccountTemplateID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Con_ContractServiceID tabeli LAccountTemplatePosition

Definicja kolumny Con_ContractServiceID tabeli LAccountTemplatePosition

Name

Con_ContractServiceID

Code

Con_ContractServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID produktu kontraktowego


Kolumna ContractServiceID tabeli LAccountTemplatePosition

Definicja kolumny ContractServiceID tabeli LAccountTemplatePosition

Name

ContractServiceID

Code

ContractServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID produktu jednostkowego


Kolumna FullName tabeli LAccountTemplatePosition

Definicja kolumny FullName tabeli LAccountTemplatePosition

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Kod i nazwa produktu kontraktowego


Kolumna UnitsCount tabeli LAccountTemplatePosition

Definicja kolumny UnitsCount tabeli LAccountTemplatePosition

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(16,4)

Mandatory

No

Comment

Ilosc jednostek rozliczeniowych


Kolumna VatRate tabeli LAccountTemplatePosition

Definicja kolumny VatRate tabeli LAccountTemplatePosition

Name

VatRate

Code

VatRate

Data Type

NUMBER(10,2)

Mandatory

No

Comment

Stawka VAT


Kolumna UnitPrice tabeli LAccountTemplatePosition

Definicja kolumny UnitPrice tabeli LAccountTemplatePosition

Name

UnitPrice

Code

UnitPrice

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Cena za jednostke rozliczeniowa


Kolumna PositionNumber tabeli LAccountTemplatePosition

Definicja kolumny PositionNumber tabeli LAccountTemplatePosition

Name

PositionNumber

Code

PositionNumber

Data Type

NUMBER(10)

Mandatory

No

Comment

Wyróznik produktu kontraktowego


Kolumna Charge tabeli LAccountTemplatePosition

Definicja kolumny Charge tabeli LAccountTemplatePosition

Name

Charge

Code

Charge

Data Type

NUMBER(14,2)

Mandatory

No

Comment

Oplata platnika


Kolumna CorrectionFactor tabeli LAccountTemplatePosition

Definicja kolumny CorrectionFactor tabeli LAccountTemplatePosition

Name

CorrectionFactor

Code

CorrectionFactor

Data Type

NUMBER(14,4)

Mandatory

No

Comment

Wspólczynnik korygujacy


Kolumna CapitationRate tabeli LAccountTemplatePosition

Definicja kolumny CapitationRate tabeli LAccountTemplatePosition

Name

CapitationRate

Code

CapitationRate

Data Type

NUMBER(14,2)

Mandatory

No

Comment

Stawka kapitacyjna


Kolumna CorrectionReason tabeli LAccountTemplatePosition

Definicja kolumny CorrectionReason tabeli LAccountTemplatePosition

Name

CorrectionReason

Code

CorrectionReason

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Lista kluczy tabeli LAccountTemplatePosition

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LAccountTemplatePosition

Definicja klucza Identifier_1 tabeli LAccountTemplatePosition

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment